﻿<%@ Page Title="SicoNide MillJet" Language="C#" MasterPageFile="~/TableMaster.master" AutoEventWireup="true" CodeFile="SicoNideMillJet.aspx.cs" Inherits="Pages_SicoNideMillJet" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <style>
        @media only screen and (max-width: 760px), (min-device-width: 768px) and (max-device-width: 1024px) {

            .resTbl tr:nth-of-type(odd) {
                background-color: #CDE2FF;
            }

            .resTbl tr:nth-of-type(1) {
                display: none;
            }

            .resTbl td:nth-of-type(1):before {
                content: "Mill";
            }

            .resTbl td:nth-of-type(2):before {
                content: "Feed Rate";
            }

            .resTbl td:nth-of-type(3):before {
                content: "Charge Number";
            }

            .resTbl td:nth-of-type(4):before {
                content: "Pressure";
            }

            .resTbl td:nth-of-type(5):before {
                content: "Flowbin Number";
            }

            .resTbl td:nth-of-type(6):before {
                content: "Quantity_Used_MJ1";
            }

            .resTbl td:nth-of-type(7):before {
                content: "SSA";
            }

            .resTbl td:nth-of-type(8):before {
                content: "Remark";
            }

            .resTbl td:nth-of-type(9):before {
                content: "Previous Process";
            }

            .resTbl td:nth-of-type(10):before {
                content: "Palla Run Number";
            }

            .resTbl td:nth-of-type(11):before {
                content: "MillJet Run Number";
            }

            .resTbl td:nth-of-type(12):before {
                content: "Created By";
            }

            .resTbl td:nth-of-type(13):before {
                content: "Created Date";
            }
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="FeaturedContent" runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Add" runat="Server">


    <asp:Panel ID="pnlAdd" runat="server">

        <table cellpadding="0" cellspacing="0" style="width: 100%;">

            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblMill" runat="server" AssociatedControlID="ddlMill" Text="Mill:"></asp:Label>
                </td>
                <td>
                    <asp:DropDownList ID="ddlMill" runat="server" DataSourceID="Ds_Mills" DataTextField="SHORT_NAME" DataValueField="MILL_ID" OnDataBound="ddlMill_DataBound"></asp:DropDownList>
                    <asp:ObjectDataSource ID="Ds_Mills" runat="server" SelectMethod="selectAll" TypeName="DAL_tbl_mills_master"></asp:ObjectDataSource>
                </td>
            </tr>
            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblFeed_Rate" runat="server" AssociatedControlID="txtFeed_Rate" Text="Feed Rate:"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtFeed_Rate" runat="server" Validate="Decimal"></asp:TextBox>
                </td>
            </tr>

            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblCharge_Number" runat="server" AssociatedControlID="txtCharge_Number" Text="Charge Number:"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtCharge_Number" runat="server" Validate="Number"></asp:TextBox>
                </td>
            </tr>

            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblPressure" runat="server" AssociatedControlID="txtPressure" Text="Pressure:"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtPressure" runat="server" Validate="Decimal"></asp:TextBox>
                </td>
            </tr>

            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblFlowbin_Number" runat="server" AssociatedControlID="txtFlowbin_Number" Text="Flowbin Number:"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtFlowbin_Number" runat="server" Validate="Number"></asp:TextBox>
                </td>
            </tr>

            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblQuantity_Used_MJ1" runat="server" AssociatedControlID="txtQuantity_Used_MJ1" Text="Quantity Used MJ1:"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtQuantity_Used_MJ1" runat="server" Validate="Number"></asp:TextBox>
                </td>
            </tr>

            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblSSA" runat="server" AssociatedControlID="txtSSA" Text="SSA:"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtSSA" runat="server" Validate="Decimal"></asp:TextBox>
                </td>
            </tr>

            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblRemark" runat="server" AssociatedControlID="txtRemark" Text="Remark:"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtRemark" runat="server" TextMode="MultiLine" Height="58px" Width="232px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblPrevious_Process" runat="server" AssociatedControlID="ddlPrevious_Process" Text="Previous Process:"></asp:Label>
                </td>
                <td>
                    <asp:DropDownList ID="ddlPrevious_Process" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlPrevious_Process_SelectedIndexChanged">
                        <asp:ListItem Value="0">--Select--</asp:ListItem>
                        <asp:ListItem>Palla</asp:ListItem>
                        <asp:ListItem>Crushing</asp:ListItem>
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblPALLA_RUN_NUMBER" runat="server" AssociatedControlID="ddlPALLA_RUN_NUMBER" Text="Palla Run Number:"></asp:Label>
                </td>
                <td>
                    <asp:DropDownList ID="ddlPALLA_RUN_NUMBER" runat="server"></asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td style="width: 170px">
                    <asp:Label ID="lblMILLJET_RUN_NUMBER" runat="server" AssociatedControlID="txtMILLJET_RUN_NUMBER" Text="MillJet Run Number:"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtMILLJET_RUN_NUMBER" runat="server" ></asp:TextBox>
                </td>
            </tr>



            <tr>
                <td style="width: 170px">&nbsp;</td>
                <td>

                    <asp:Button ID="btnSave" runat="server" CssClass="btn btn-success" OnClick="btnSave_Click" Text="Save" Width="90px" />
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                    <asp:Button ID="btnCancel" runat="server" CssClass="btn btn-danger" OnClick="btnCancel_Click" Text="Cancel" Width="90px" />

                </td>
            </tr>

        </table>

    </asp:Panel>

</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="Grid" runat="Server">

    <asp:Panel ID="pnlList" runat="server">
        <asp:GridView ID="gridClients" runat="server" AutoGenerateColumns="False" CssClass="resTbl" DataSourceID="DS_tbl_siconide_milljet">
            <Columns>
                <asp:BoundField DataField="Mill" HeaderText="Mill" SortExpression="Mill" />

                <asp:BoundField DataField="Feed_Rate" HeaderText="Feed Rate" SortExpression="Feed_Rate" />
                <asp:BoundField DataField="Charge_Number" HeaderText="Charge Number" SortExpression="Charge_Number" />
                <asp:BoundField DataField="Pressure" HeaderText="Pressure" SortExpression="Pressure" />
                <asp:BoundField DataField="Flowbin_Number" HeaderText="Flowbin Number" SortExpression="Flowbin_Number" />
                <asp:BoundField DataField="Quantity_Used_MJ1" HeaderText="Quantity_Used_MJ1" SortExpression="Quantity_Used_MJ1" />
                <asp:BoundField DataField="SSA" HeaderText="SSA" SortExpression="SSA" />
                <asp:BoundField DataField="Remark" HeaderText="Remark" SortExpression="Remark" />

                <asp:BoundField DataField="Previous_Process" HeaderText="Previous Process" SortExpression="Previous_Process" />
                <asp:BoundField DataField="PALLA_RUN_NUMBER" HeaderText="Palla Run Number" SortExpression="PALLA_RUN_NUMBER" />
                <asp:BoundField DataField="MILLJET_RUN_NUMBER" HeaderText="MillJet Run Number" SortExpression="MILLJET_RUN_NUMBER" />

                <asp:BoundField DataField="CREATED_BY" HeaderText="Created By" SortExpression="CREATED_BY" />
                <asp:BoundField DataField="CREATED_DATE" HeaderText="Created Date" SortExpression="CREATED_DATE" DataFormatString="{0:yyMMdd}" />

                <asp:TemplateField HeaderText="Edit">
                    <ItemTemplate>
                        <asp:LinkButton ID="linkEdit" runat="server" Text="Edit" CommandArgument='<%# Eval("ID") %>' OnClick="linkEdit_Click"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Delete">
                    <ItemTemplate>
                        <asp:LinkButton ID="linkDelete" CommandName="delete" runat="server" Text="Delete" OnClientClick="javascript:return confirm('Are you sure you want to delete this record?');" CommandArgument='<%# Eval("ID") %>' OnClick="linkDelete_Click"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
        <asp:ObjectDataSource ID="DS_tbl_siconide_milljet" runat="server" SelectMethod="selectAllForGrid" DeleteMethod="delete" InsertMethod="insert" UpdateMethod="update" TypeName="DAL_tbl_siconide_milljet">
            <DeleteParameters>
                <asp:Parameter Name="ID" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="Mill" Type="Int32" />
                <asp:Parameter Name="Feed_Rate" Type="Decimal" />
                <asp:Parameter Name="Charge_Number" Type="Decimal" />
                <asp:Parameter Name="Pressure" Type="Decimal" />
                <asp:Parameter Name="Flowbin_Number" Type="Decimal" />
                <asp:Parameter Name="Quantity_Used_MJ1" Type="Decimal" />
                <asp:Parameter Name="SSA" Type="Decimal" />
                <asp:Parameter Name="Remark" Type="String" />
                <asp:Parameter Name="Previous_Process" Type="String" />
                <asp:Parameter Name="PALLA_RUN_NUMBER" Type="String" />
                <asp:Parameter Name="MILLJET_RUN_NUMBER" Type="String" />
                <asp:Parameter Name="CREATED_BY" Type="String" />
                <asp:Parameter Name="CREATED_DATE" Type="DateTime" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Mill" Type="Int32" />
                <asp:Parameter Name="Feed_Rate" Type="Decimal" />
                <asp:Parameter Name="Charge_Number" Type="Decimal" />
                <asp:Parameter Name="Pressure" Type="Decimal" />
                <asp:Parameter Name="Flowbin_Number" Type="Decimal" />
                <asp:Parameter Name="Quantity_Used_MJ1" Type="Decimal" />
                <asp:Parameter Name="SSA" Type="Decimal" />
                <asp:Parameter Name="Remark" Type="String" />
                <asp:Parameter Name="Previous_Process" Type="String" />
                <asp:Parameter Name="PALLA_RUN_NUMBER" Type="String" />
                <asp:Parameter Name="MILLJET_RUN_NUMBER" Type="String" />
                <asp:Parameter Name="UPDATED_BY" Type="String" />
                <asp:Parameter Name="UPDATED_DATE" Type="DateTime" />
            </UpdateParameters>
        </asp:ObjectDataSource>
    </asp:Panel>

</asp:Content>

